<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1600.1">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="INSERT INTO [People]([firstname]) values(@1)" StatementId="1" StatementCompId="1" StatementType="INSERT" StatementSubTreeCost="0.0100025" StatementEstRows="1" StatementOptmLevel="TRIVIAL" QueryHash="0xD86F0EB2280A7120" QueryPlanHash="0xCD4D30FEDFE15E89">
          <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/>
          <QueryPlan DegreeOfParallelism="0" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="72">
            <RelOp NodeId="0" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0100025" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList/>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
              </RunTimeInformation>
              <Assert StartupExpression="0">
                <RelOp NodeId="1" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0100024" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
                  </RunTimeInformation>
                  <Update DMLRequestSort="0">
                    <Object Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Index="[PK_People_id]" IndexKind="Clustered"/>
                    <SetPredicate>
                      <ScalarOperator ScalarString="[StackOverflow].[dbo].[People].[firstname] = [Expr1004],[StackOverflow].[dbo].[People].[id] = [Expr1003],[StackOverflow].[dbo].[People].[lastname] = NULL,[StackOverflow].[dbo].[People].[age] = NULL">
                        <ScalarExpressionList>
                          <ScalarOperator>
                            <MultipleAssign>
                              <Assign>
                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="firstname"/>
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="Expr1004"/>
                                  </Identifier>
                                </ScalarOperator>
                              </Assign>
                              <Assign>
                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="id"/>
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="Expr1003"/>
                                  </Identifier>
                                </ScalarOperator>
                              </Assign>
                              <Assign>
                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="lastname"/>
                                <ScalarOperator>
                                  <Const ConstValue="NULL"/>
                                </ScalarOperator>
                              </Assign>
                              <Assign>
                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                                <ScalarOperator>
                                  <Const ConstValue="NULL"/>
                                </ScalarOperator>
                              </Assign>
                            </MultipleAssign>
                          </ScalarOperator>
                        </ScalarExpressionList>
                      </ScalarOperator>
                    </SetPredicate>
                    <RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="40" EstimatedTotalSubtreeCost="1.357e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                      <OutputList>
                        <ColumnReference Column="Expr1003"/>
                        <ColumnReference Column="Expr1004"/>
                      </OutputList>
                      <ComputeScalar>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1004"/>
                            <ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(50),[@1],0)">
                              <Convert DataType="varchar" Length="50" Style="0" Implicit="1">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="@1"/>
                                  </Identifier>
                                </ScalarOperator>
                              </Convert>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="1.257e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                          <OutputList>
                            <ColumnReference Column="Expr1003"/>
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
                          </RunTimeInformation>
                          <ComputeScalar>
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Column="Expr1003"/>
                                <ScalarOperator ScalarString="getidentity((2105058535),(6),NULL)">
                                  <Intrinsic FunctionName="getidentity">
                                    <ScalarOperator>
                                      <Const ConstValue="(2105058535)"/>
                                    </ScalarOperator>
                                    <ScalarOperator>
                                      <Const ConstValue="(6)"/>
                                    </ScalarOperator>
                                    <ScalarOperator>
                                      <Const ConstValue="NULL"/>
                                    </ScalarOperator>
                                  </Intrinsic>
                                </ScalarOperator>
                              </DefinedValue>
                            </DefinedValues>
                            <RelOp NodeId="4" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                              <OutputList/>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
                              </RunTimeInformation>
                              <ConstantScan/>
                            </RelOp>
                          </ComputeScalar>
                        </RelOp>
                      </ComputeScalar>
                    </RelOp>
                  </Update>
                </RelOp>
                <Predicate>
                  <ScalarOperator ScalarString="CASE WHEN [StackOverflow].[dbo].[People].[age]&lt;(0) OR [StackOverflow].[dbo].[People].[age]&gt;=(200) THEN (0) ELSE NULL END">
                    <IF>
                      <Condition>
                        <ScalarOperator>
                          <Logical Operation="OR">
                            <ScalarOperator>
                              <Compare CompareOp="LT">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                                  </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Const ConstValue="(0)"/>
                                </ScalarOperator>
                              </Compare>
                            </ScalarOperator>
                            <ScalarOperator>
                              <Compare CompareOp="GE">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                                  </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Const ConstValue="(200)"/>
                                </ScalarOperator>
                              </Compare>
                            </ScalarOperator>
                          </Logical>
                        </ScalarOperator>
                      </Condition>
                      <Then>
                        <ScalarOperator>
                          <Const ConstValue="(0)"/>
                        </ScalarOperator>
                      </Then>
                      <Else>
                        <ScalarOperator>
                          <Const ConstValue="NULL"/>
                        </ScalarOperator>
                      </Else>
                    </IF>
                  </ScalarOperator>
                </Predicate>
              </Assert>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@1" ParameterCompiledValue="&apos;Friday&apos;" ParameterRuntimeValue="&apos;Friday&apos;"/>
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>